You filter a FlexTable by creating a query. You can filter a Flextable with selection an existing query, or by constructing a new query with the Query Builder dialog.

Open the FlexTable you want to filter. Right-click the column heading you want to filter, and select between two Filtering options, Filter By Query and Custom Filter.

Filter By Query

Select from a list of defined project queries. When a query is selected the subset of rows satisfying the condition will remain visible in the Flextable.

Custom Filter

1. The Query Builder dialog box opens.
2. All input and results fields for the selected element type appear in the Fields list pane, available SQL operators and keywords are represented by buttons, and available values for the selected field are listed in the Unique Values list pane. Perform the following steps to construct your query:
3. Double-click the field you wish to include in your query. The database column name of the selected field appears in the preview pane.
4. Click the desired operator or keyword button. The SQL operator or keyword is added to the SQL expression in the preview pane.
5. Click the Refresh button above the Unique Values list pane to see a list of unique values available for the selected field. The Refresh button is becomes disabled after you use it for a particular field.
6. Double-click the unique value you want to add to the query. The value is added to the SQL expression in the preview pane.
7. Click the Validate button above the preview pane to validate your SQL expression. If the expression is valid, the word "VALIDATED" is displayed in the lower right corner of the dialog box.
8. Click the Apply button above the preview pane to execute the query. If you didn’t validate the expression, the Apply button validates it before executing it.
9. Click OK.

The FlexTable displays columns of data for all elements returned by the query and the word "FILTERED" is displayed in the FlexTable status bar.

To reset a filter:

1. Right-click the column heading you want to filter.
2. Select Filter.
3. Click Reset.

The status pane at the bottom of the Table window always shows the number of rows displayed and the total number of rows available (e.g., 10 of 20 elements displayed). When a filter is active, this message is highlighted.